/*
 Navicat Premium Data Transfer

 Source Server         : yh-local
 Source Server Type    : MySQL
 Source Server Version : 80026
 Source Host           : localhost:3306
 Source Schema         : aishouyu_web

 Target Server Type    : MySQL
 Target Server Version : 80026
 File Encoding         : 65001

 Date: 17/04/2024 16:02:17
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for app_notice
-- ----------------------------
DROP TABLE IF EXISTS `app_notice`;
CREATE TABLE `app_notice` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `version` varchar(15) NOT NULL COMMENT '版本号',
  `title` varchar(255) DEFAULT NULL COMMENT '公告标题',
  `content` text COMMENT '公告内容',
  `summary` text COMMENT '结语',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标记，0未删除，1已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='APP公告';

-- ----------------------------
-- Records of app_notice
-- ----------------------------
BEGIN;
INSERT INTO `app_notice` VALUES (1, '1.0.0', '11', '11', '22', '0');
INSERT INTO `app_notice` VALUES (2, '1.0.1', '22', '22', '22', '0');
INSERT INTO `app_notice` VALUES (3, '1.1.0', '33', '33', '33', '0');
INSERT INTO `app_notice` VALUES (4, '1.0.1.2', '44', '44', '44', '0');
COMMIT;

-- ----------------------------
-- Table structure for app_version
-- ----------------------------
DROP TABLE IF EXISTS `app_version`;
CREATE TABLE `app_version` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `platform` char(2) NOT NULL COMMENT '平台 1-安卓 2-IOS',
  `version` varchar(15) NOT NULL COMMENT '版本号',
  `force_update` char(1) DEFAULT '0' COMMENT '是否强制更新 0-否，1-是',
  `jump_link` varchar(300) DEFAULT NULL COMMENT '跳转链接',
  `update_content` text COMMENT '更新内容',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标记，0未删除，1已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1729866884129124355 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='APP版本信息';

-- ----------------------------
-- Records of app_version
-- ----------------------------
BEGIN;
INSERT INTO `app_version` VALUES (1729866425729445890, '1', '1.0.0', '0', '', 'APP版本测试', '0');
INSERT INTO `app_version` VALUES (1729866461913706497, '1', '1.0.1', '0', '', 'APP版本测试2', '0');
INSERT INTO `app_version` VALUES (1729866495061291010, '1', '1.1.0', '0', '', 'APP版本测试3', '0');
COMMIT;

-- ----------------------------
-- Table structure for chat_history
-- ----------------------------
DROP TABLE IF EXISTS `chat_history`;
CREATE TABLE `chat_history` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `member_id` bigint NOT NULL COMMENT '会员ID',
  `message_id` varchar(128) NOT NULL COMMENT '消息ID',
  `content` text NOT NULL COMMENT '消息内容',
  `time` datetime NOT NULL COMMENT '时间',
  `type` tinyint DEFAULT '1' COMMENT '消息类型：1常用语，2正常人语音，3键盘输入4手语识别',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标记，0未删除，1已删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1743635007009779715 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='聊天记录';

-- ----------------------------
-- Records of chat_history
-- ----------------------------
BEGIN;
INSERT INTO `chat_history` VALUES (1743614352939843585, 1735303241643601922, 'd8b4744595be40eea58b22e913152c51', '你好，很高兴认识你', '2024-01-06 20:43:51', 1, '0');
INSERT INTO `chat_history` VALUES (1743635007009779714, 1735303241643601922, 'd83f9d598ea740ff8fda1848335cff57', '今天天气真好', '2024-01-06 22:05:55', 2, '0');
COMMIT;

-- ----------------------------
-- Table structure for chat_phrase
-- ----------------------------
DROP TABLE IF EXISTS `chat_phrase`;
CREATE TABLE `chat_phrase` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `member_id` bigint NOT NULL COMMENT '会员ID',
  `content` text COMMENT '常用语内容',
  `label_id` bigint DEFAULT NULL COMMENT '标签ID',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标记，0未删除，1已删除',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `phrase_member_id` (`member_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1730227690654019586 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='聊天常用语';

-- ----------------------------
-- Records of chat_phrase
-- ----------------------------
BEGIN;
INSERT INTO `chat_phrase` VALUES (1730212957066493954, 1730211451122642945, '测试测试测试测试测试', 1729863968584503298, '0');
INSERT INTO `chat_phrase` VALUES (1730227283064139778, 1730211451122642945, '与家人常用语与家人常用语与家人常用语与家人常用语与家人常用语', 1730211451122642945, '0');
INSERT INTO `chat_phrase` VALUES (1730227477772120066, 1730211451122642945, '与家人常用语与家人常用语与家人常用语与家人常用语与家人常用语', 1729864115003461633, '0');
INSERT INTO `chat_phrase` VALUES (1730227690654019585, 1730211451122642945, '窗口办事常用语窗口办事常用语窗口办事常用语窗口办事常用语', 1729864151355494401, '0');
COMMIT;

-- ----------------------------
-- Table structure for chat_phrase_label
-- ----------------------------
DROP TABLE IF EXISTS `chat_phrase_label`;
CREATE TABLE `chat_phrase_label` (
  `label_id` bigint NOT NULL AUTO_INCREMENT COMMENT '标签ID',
  `label_name` varchar(255) NOT NULL COMMENT '标签名称',
  `sort` int DEFAULT NULL COMMENT '排序',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标记，0未删除，1已删除',
  PRIMARY KEY (`label_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1729864151355494402 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='聊天常用语分组标签';

-- ----------------------------
-- Records of chat_phrase_label
-- ----------------------------
BEGIN;
INSERT INTO `chat_phrase_label` VALUES (1729863968584503298, '与陌生人', 0, '0');
INSERT INTO `chat_phrase_label` VALUES (1729864115003461633, '与家人', 1, '0');
INSERT INTO `chat_phrase_label` VALUES (1729864151355494401, '窗口办事', 2, '0');
COMMIT;

-- ----------------------------
-- Table structure for member
-- ----------------------------
DROP TABLE IF EXISTS `member`;
CREATE TABLE `member` (
  `member_id` bigint NOT NULL AUTO_INCREMENT COMMENT '会员ID',
  `username` varchar(64) DEFAULT NULL COMMENT '会员名',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `phone` varchar(20) DEFAULT NULL COMMENT '电话号码',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `nickname` varchar(64) DEFAULT NULL COMMENT '昵称',
  `sex` tinyint(1) DEFAULT NULL COMMENT '性别 1:男 2:女',
  `birthday` varchar(32) DEFAULT NULL COMMENT '生日',
  `id_card` varchar(32) DEFAULT NULL COMMENT '身份证号',
  `real_name` varchar(32) DEFAULT NULL COMMENT '真实姓名',
  `signature` text COMMENT '个性签名',
  `country` varchar(255) DEFAULT NULL COMMENT '国家',
  `province` varchar(255) DEFAULT NULL COMMENT '省',
  `city` varchar(255) DEFAULT NULL COMMENT '城市',
  `email` varchar(128) DEFAULT NULL COMMENT '邮箱地址',
  `wx_openid` varchar(32) DEFAULT NULL COMMENT '微信登录openId',
  `mini_openid` varchar(32) DEFAULT NULL COMMENT '小程序openId',
  `qq_openid` varchar(32) DEFAULT NULL COMMENT 'QQ openId',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `lock_flag` char(1) DEFAULT '0' COMMENT '锁定标记，0未锁定，9已锁定',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标记，0未删除，1已删除',
  PRIMARY KEY (`member_id`) USING BTREE,
  KEY `user_wx_openid` (`wx_openid`) USING BTREE,
  KEY `user_qq_openid` (`qq_openid`) USING BTREE,
  KEY `user_idx1_username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1735303241643601923 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='会员表';

-- ----------------------------
-- Records of member
-- ----------------------------
BEGIN;
INSERT INTO `member` VALUES (1730211451122642945, 'admin@qq.com', '123456', '13837888888', '', 'SuperWein', 1, '', '', '', '', '', '', '', '', '', '', '', '2023-11-30 21:05:30', NULL, '0', '0');
INSERT INTO `member` VALUES (1735303241643601922, NULL, NULL, '13524142329', NULL, 'aaron', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-12-14 22:18:27', '2024-01-06 22:08:26', '0', '0');
COMMIT;

-- ----------------------------
-- Table structure for member_sign
-- ----------------------------
DROP TABLE IF EXISTS `member_sign`;
CREATE TABLE `member_sign` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `member_id` bigint NOT NULL COMMENT '会员ID',
  `sign_time` datetime NOT NULL COMMENT '签到时间',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标记，0未删除，1已删除',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `sign_member_id` (`member_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1730591220280487940 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户签到记录';

-- ----------------------------
-- Records of member_sign
-- ----------------------------
BEGIN;
INSERT INTO `member_sign` VALUES (1730212393196847106, 1730211451122642945, '2023-11-30 21:09:14', '0');
INSERT INTO `member_sign` VALUES (1730591220280487938, 1730211451122642945, '2023-12-01 22:14:34', '0');
INSERT INTO `member_sign` VALUES (1730591220280487939, 1730211451122642945, '2023-12-03 22:15:36', '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
  `config_id` bigint NOT NULL AUTO_INCREMENT COMMENT '参数主键',
  `config_name` varchar(100) DEFAULT '' COMMENT '参数名称',
  `config_key` varchar(100) DEFAULT '' COMMENT '参数键名',
  `config_value` varchar(500) DEFAULT '' COMMENT '参数键值',
  `config_type` char(1) DEFAULT 'N' COMMENT '系统内置（Y是 N否）',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`config_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1730833732903550979 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='参数配置表';

-- ----------------------------
-- Records of sys_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_config` VALUES (1, '用户调研链接', 'app.userSurvey.url', 'http://用户调研.com', 'N', '', '2023-11-29 20:02:28', '2023-12-02 14:17:59');
INSERT INTO `sys_config` VALUES (2, '故障提交链接', 'app.faultSubmit.url', 'http://故障提交.com', 'N', NULL, '2023-11-29 20:05:33', '2023-11-29 20:05:35');
INSERT INTO `sys_config` VALUES (3, '用户建议链接', 'app.userSuggest.url', 'http://用户建议.com', 'N', NULL, '2023-11-29 20:06:45', '2023-12-02 14:32:46');
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `id` bigint NOT NULL COMMENT '主键',
  `name` varchar(32) NOT NULL COMMENT '部门名称',
  `parent_id` bigint NOT NULL COMMENT '父id',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态，0：禁用，1：启用',
  `sort` int NOT NULL DEFAULT '0' COMMENT '排序',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `sys_dept_name_index` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='部门';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` VALUES (1, 'aishouyu-web', 0, 1, 0, '2023-06-18 13:48:13', NULL);
INSERT INTO `sys_dept` VALUES (2, '技术部', 1, 1, 1, '2023-06-18 13:48:13', NULL);
INSERT INTO `sys_dept` VALUES (3, '测试部', 1, 1, 2, '2023-06-18 13:48:13', NULL);
INSERT INTO `sys_dept` VALUES (21, '技术一部', 2, 1, 1, '2023-06-18 13:48:13', '2023-06-20 22:19:32');
INSERT INTO `sys_dept` VALUES (22, '技术二部', 2, 1, 2, '2023-06-18 13:48:13', NULL);
INSERT INTO `sys_dept` VALUES (23, '技术三部', 2, 1, 3, '2023-06-18 13:48:13', NULL);
INSERT INTO `sys_dept` VALUES (24, '技术四部', 2, 1, 4, '2023-06-18 13:48:13', NULL);
INSERT INTO `sys_dept` VALUES (25, '技术五部', 2, 1, 5, '2023-06-18 13:48:13', '2023-06-21 07:45:56');
INSERT INTO `sys_dept` VALUES (31, '测试一部', 3, 1, 1, '2023-06-18 13:48:13', NULL);
INSERT INTO `sys_dept` VALUES (32, '测试二部', 3, 1, 2, '2023-06-18 13:48:13', NULL);
INSERT INTO `sys_dept` VALUES (33, '测试三部', 3, 1, 3, '2023-06-18 13:48:13', NULL);
INSERT INTO `sys_dept` VALUES (34, '测试四部', 3, 1, 4, '2023-06-18 13:48:13', NULL);
INSERT INTO `sys_dept` VALUES (35, '测试五部', 3, 1, 10, '2023-06-18 13:48:13', '2023-06-20 22:37:25');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_data`;
CREATE TABLE `sys_dict_data` (
  `dict_code` bigint NOT NULL COMMENT '字典编码',
  `dict_sort` int DEFAULT '0' COMMENT '字典排序',
  `dict_label` varchar(100) DEFAULT '' COMMENT '字典标签',
  `dict_value` varchar(100) DEFAULT '' COMMENT '字典键值',
  `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
  `css_class` varchar(100) DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
  `list_class` varchar(100) DEFAULT NULL COMMENT '表格回显样式',
  `is_default` char(1) DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='字典数据表';

-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;
CREATE TABLE `sys_dict_type` (
  `dict_id` bigint NOT NULL COMMENT '字典主键',
  `dict_name` varchar(100) DEFAULT '' COMMENT '字典名称',
  `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_id`),
  UNIQUE KEY `dict_type` (`dict_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='字典类型表';

-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `id` bigint NOT NULL COMMENT '主键',
  `trace_id` varchar(36) DEFAULT NULL COMMENT '日志链路ID',
  `request_time` varchar(30) DEFAULT NULL COMMENT '请求时间',
  `request_url` varchar(1000) DEFAULT NULL COMMENT '全路径',
  `permission_code` varchar(200) DEFAULT NULL COMMENT '权限编码',
  `log_name` varchar(200) DEFAULT NULL COMMENT '日志名称',
  `request_method` varchar(10) DEFAULT NULL COMMENT '请求方式，GET/POST',
  `content_type` varchar(200) DEFAULT NULL COMMENT '内容类型',
  `is_request_body` tinyint(1) DEFAULT NULL COMMENT '是否是JSON请求映射参数',
  `token` varchar(100) DEFAULT NULL COMMENT 'token',
  `module_name` varchar(100) DEFAULT NULL COMMENT '模块名称',
  `class_name` varchar(200) DEFAULT NULL COMMENT 'controller类名称',
  `method_name` varchar(200) DEFAULT NULL COMMENT 'controller方法名称',
  `request_param` text COMMENT '请求参数',
  `user_id` bigint DEFAULT NULL COMMENT '用户ID',
  `username` varchar(100) DEFAULT NULL COMMENT '用户名',
  `request_ip` varchar(15) DEFAULT NULL COMMENT '请求ip',
  `ip_country` varchar(100) DEFAULT NULL COMMENT 'IP国家',
  `ip_province` varchar(100) DEFAULT NULL COMMENT 'IP省份',
  `ip_city` varchar(100) DEFAULT NULL COMMENT 'IP城市',
  `ip_area_desc` varchar(100) DEFAULT NULL COMMENT 'IP区域描述',
  `ip_isp` varchar(100) DEFAULT NULL COMMENT 'IP运营商',
  `log_type` int NOT NULL DEFAULT '0' COMMENT '0:其它,1:新增,2:修改,3:删除,4:详情查询,5:所有列表,6:分页列表,7:其它查询,8:上传文件',
  `response_time` varchar(100) DEFAULT NULL COMMENT '响应时间',
  `response_success` tinyint(1) DEFAULT NULL COMMENT '0:失败,1:成功',
  `response_code` int DEFAULT NULL COMMENT '响应结果状态码',
  `response_message` text COMMENT '响应结果消息',
  `response_data` text COMMENT '响应数据',
  `exception_name` varchar(200) DEFAULT NULL COMMENT '异常类名称',
  `exception_message` text COMMENT '异常信息',
  `diff_time` bigint DEFAULT NULL COMMENT '耗时，单位：毫秒',
  `diff_time_desc` varchar(100) DEFAULT NULL COMMENT '耗时描述',
  `referer` varchar(1000) DEFAULT NULL COMMENT '请求来源地址',
  `origin` varchar(1000) DEFAULT NULL COMMENT '请求来源服务名',
  `source_type` varchar(100) DEFAULT NULL COMMENT '请求来源类型',
  `is_mobile` tinyint(1) DEFAULT NULL COMMENT '是否手机 0：否，1：是',
  `platform_name` varchar(100) DEFAULT NULL COMMENT '平台名称',
  `browser_name` varchar(100) DEFAULT NULL COMMENT '浏览器名称',
  `user_agent` varchar(1000) DEFAULT NULL COMMENT '用户环境',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `sys_log_log_name_index` (`log_name`),
  KEY `sys_log_log_type_index` (`log_type`),
  KEY `sys_log_module_name_index` (`module_name`),
  KEY `sys_log_permission_code_index` (`permission_code`),
  KEY `sys_log_request_ip_index` (`request_ip`),
  KEY `sys_log_response_success_index` (`response_success`),
  KEY `sys_log_trace_id_index` (`trace_id`),
  KEY `sys_log_username_index` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统日志';

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_login_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_login_log`;
CREATE TABLE `sys_login_log` (
  `id` bigint NOT NULL COMMENT '主键',
  `request_id` varchar(32) DEFAULT NULL COMMENT '请求ID',
  `username` varchar(32) DEFAULT NULL COMMENT '用户名称',
  `ip` varchar(15) DEFAULT NULL COMMENT 'IP',
  `token` varchar(32) DEFAULT NULL COMMENT 'token',
  `type` int DEFAULT NULL COMMENT '1:登录，2：登出',
  `success` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否成功 true:成功/false:失败',
  `code` int DEFAULT NULL COMMENT '响应码',
  `exception_message` varchar(300) DEFAULT NULL COMMENT '失败消息记录',
  `user_agent` varchar(300) DEFAULT NULL COMMENT '用户环境',
  `browser_name` varchar(100) DEFAULT NULL COMMENT '浏览器名称',
  `browser_version` varchar(100) DEFAULT NULL COMMENT '浏览器版本',
  `engine_name` varchar(100) DEFAULT NULL COMMENT '浏览器引擎名称',
  `engine_version` varchar(100) DEFAULT NULL COMMENT '浏览器引擎版本',
  `os_name` varchar(100) DEFAULT NULL COMMENT '系统名称',
  `platform_name` varchar(100) DEFAULT NULL COMMENT '平台名称',
  `mobile` tinyint(1) DEFAULT NULL COMMENT '是否是手机,0:否,1:是',
  `device_model` varchar(100) DEFAULT NULL COMMENT '移动端设备型号',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统登录日志';

-- ----------------------------
-- Records of sys_login_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` bigint NOT NULL COMMENT '主键',
  `name` varchar(32) DEFAULT NULL COMMENT '菜单名称',
  `parent_id` bigint NOT NULL COMMENT '父id',
  `code` varchar(100) DEFAULT NULL COMMENT '菜单唯一编码',
  `icon` varchar(100) DEFAULT NULL COMMENT '菜单图标',
  `type` tinyint NOT NULL COMMENT '菜单类型，1：菜单，2：外链，3：权限',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态，0：禁用，1：启用',
  `sort` int NOT NULL DEFAULT '0' COMMENT '排序',
  `route_url` varchar(200) DEFAULT NULL COMMENT '前端路由地址',
  `route_name` varchar(20) DEFAULT NULL COMMENT '路由名称',
  `route_redirect` varchar(100) DEFAULT NULL COMMENT '重定向',
  `component_path` varchar(100) DEFAULT NULL COMMENT '组件路径',
  `is_show` tinyint(1) DEFAULT NULL COMMENT '是否显示,0：不显示，1：显示',
  `is_cache` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否缓存，0：否 1：是',
  `is_link` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否外链，0：否 1：是',
  `is_home` tinyint(1) DEFAULT '0' COMMENT '是否首页 0：否，1：是',
  `link_url` varchar(100) DEFAULT NULL COMMENT '链接地址',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `sys_permission_code_uindex` (`code`),
  KEY `sys_menu_name_index` (`name`),
  KEY `sys_menu_status_index` (`status`),
  KEY `sys_menu_type_index` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统菜单';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (10, '首页', 0, 'Home', 'ele-house', 1, 1, 0, '/home', 'Home', NULL, 'dashboard/index', 1, 0, 0, 1, NULL, '2023-05-27 11:31:28', '2023-06-21 12:51:44');
INSERT INTO `sys_menu` VALUES (11, '系统管理', 0, 'system', 'ele-setting', 1, 1, 10, '/system', 'System', '/user', 'Layout', 1, 0, 0, 0, NULL, '2023-05-27 12:02:42', '2023-12-02 13:37:43');
INSERT INTO `sys_menu` VALUES (1101, '用户管理', 11, 'User', 'ele-user', 1, 1, 1, '/user', 'User', NULL, 'system/user/index', 1, 0, 0, 0, NULL, '2023-05-27 12:04:05', '2023-06-16 09:08:20');
INSERT INTO `sys_menu` VALUES (1102, '角色管理', 11, 'role', 'local-role', 1, 1, 2, '/role', 'Role', NULL, 'system/role/index', 1, 1, 0, 0, NULL, '2023-06-18 08:02:48', NULL);
INSERT INTO `sys_menu` VALUES (1103, '菜单管理', 11, 'menu', 'local-menu', 1, 1, 3, '/menu', 'Menu', NULL, 'system/menu/index', 1, 1, 0, 0, NULL, '2023-06-18 08:03:32', NULL);
INSERT INTO `sys_menu` VALUES (1104, '部门管理', 11, 'dept', 'local-dept', 1, 1, 4, '/dept', 'Dept', NULL, 'system/dept/index', 1, 0, 0, 0, NULL, '2023-06-18 08:01:35', NULL);
INSERT INTO `sys_menu` VALUES (1105, '日志管理', 11, 'log', 'ele-memo', 1, 1, 10, '/log', 'Log', '/operationLog', 'Layout', 1, 0, 0, 0, NULL, '2023-06-23 21:06:44', '2023-12-02 13:37:50');
INSERT INTO `sys_menu` VALUES (110101, '添加用户', 1101, 'sys:user:add', NULL, 3, 1, 1, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110102, '修改用户', 1101, 'sys:user:update', NULL, 3, 1, 2, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110103, '删除用户', 1101, 'sys:user:delete', NULL, 3, 1, 3, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110104, '用户详情', 1101, 'sys:user:info', NULL, 3, 1, 4, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110105, '用户列表', 1101, 'sys:user:list', NULL, 3, 1, 5, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110106, '重置用户密码', 1101, 'sys:user:reset-password', NULL, 3, 1, 6, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110107, '修改用户密码', 1101, 'sys:user:update-password', NULL, 3, 1, 6, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110108, '获取个人信息', 1101, 'sys:user:profile', NULL, 3, 1, 6, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110109, '修改个人信息', 1101, 'sys:user:update-profile', NULL, 3, 1, 6, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110201, '添加角色', 1102, 'sys:role:add', NULL, 3, 1, 1, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110202, '修改角色', 1102, 'sys:role:update', NULL, 3, 1, 2, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110203, '删除角色', 1102, 'sys:role:delete', NULL, 3, 1, 3, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110204, '角色详情', 1102, 'sys:role:info', NULL, 3, 1, 4, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110205, '角色列表', 1102, 'sys:role:list', NULL, 3, 1, 5, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110206, '所有角色列表', 1102, 'sys:role:all-list', NULL, 3, 1, 5, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110207, '设置角色权限', 1102, 'sys:role:set-role-menus', NULL, 3, 1, 5, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110208, '角色权限ID集合', 1102, 'sys:role:menu-ids', NULL, 3, 1, 5, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110301, '添加菜单', 1103, 'sys:menu:add', NULL, 3, 1, 1, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110302, '修改菜单', 1103, 'sys:menu:update', NULL, 3, 1, 2, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110303, '删除菜单', 1103, 'sys:menu:delete', NULL, 3, 1, 3, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110304, '菜单详情', 1103, 'sys:menu:info', NULL, 3, 1, 4, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110305, '菜单树形列表', 1103, 'sys:menu:tree-list', NULL, 3, 1, 5, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110306, '所有的菜单树形列表', 1103, 'sys:menu:all-tree-list', NULL, 3, 1, 5, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110307, '导航菜单', 1103, 'sys:menu:nav-tree-list', NULL, 3, 1, 5, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110401, '添加部门', 1104, 'sys:dept:add', NULL, 3, 1, 1, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110402, '修改部门', 1104, 'sys:dept:update', NULL, 3, 1, 2, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110403, '删除部门', 1104, 'sys:dept:delete', NULL, 3, 1, 3, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110404, '部门详情', 1104, 'sys:dept:info', NULL, 3, 1, 4, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110405, '部门树形列表', 1104, 'sys:dept:tree-list', NULL, 3, 1, 5, NULL, NULL, NULL, NULL, 1, 0, 0, 0, NULL, '2023-06-18 20:22:12', NULL);
INSERT INTO `sys_menu` VALUES (110501, '操作日志', 1105, 'operationLog', 'ele-expand', 1, 1, 1, '/operationLog', 'OperationLog', NULL, 'system/operationLog/index', 1, 1, 0, 0, NULL, '2023-06-23 21:23:40', '2023-06-24 16:17:55');
INSERT INTO `sys_menu` VALUES (11050101, '日志详情', 110501, 'sys:log:info', NULL, 3, 1, 2, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, NULL, '2023-06-23 21:11:00', '2023-06-23 21:24:05');
INSERT INTO `sys_menu` VALUES (11050102, '日志列表', 110501, 'sys:log:list', NULL, 3, 1, 3, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, NULL, '2023-06-23 21:12:04', '2023-06-23 21:24:13');
INSERT INTO `sys_menu` VALUES (1730800447573925890, '运营管理', 0, 'operation', 'ele-data-analysis', 1, 1, 1, '/operation', 'Operation', NULL, 'Layout', 1, 0, 0, 0, NULL, '2023-12-02 12:05:58', '2023-12-02 12:09:17');
INSERT INTO `sys_menu` VALUES (1730800861144883201, '会员管理', 0, 'members', 'ele-avatar', 1, 1, 2, '/members', 'Members', NULL, 'Layout', 1, 0, 0, 0, NULL, '2023-12-02 12:07:36', '2023-12-02 16:33:41');
INSERT INTO `sys_menu` VALUES (1730823165987954690, '系统参数管理', 11, 'config', 'ele-setting', 1, 1, 5, '/config', 'Config', NULL, 'system/config/index', 1, 0, 0, 0, NULL, '2023-12-02 13:36:14', '2023-12-02 13:37:29');
INSERT INTO `sys_menu` VALUES (1730823811571032066, '添加参数配置', 1730823165987954690, 'sys:config:add', NULL, 3, 1, 1, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, NULL, '2023-12-02 13:38:48', NULL);
INSERT INTO `sys_menu` VALUES (1730823936435462145, '修改参数配置', 1730823165987954690, 'sys:config:update', NULL, 3, 1, 2, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, NULL, '2023-12-02 13:39:18', NULL);
INSERT INTO `sys_menu` VALUES (1730824059148214274, '删除参数配置', 1730823165987954690, 'sys:config:delete', NULL, 3, 1, 3, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, NULL, '2023-12-02 13:39:47', NULL);
INSERT INTO `sys_menu` VALUES (1730824180753670145, '参数配置详情', 1730823165987954690, 'sys:config:info', NULL, 3, 1, 4, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, NULL, '2023-12-02 13:40:16', NULL);
INSERT INTO `sys_menu` VALUES (1730824330792312833, '参数配置分页列表', 1730823165987954690, 'sys:config:list', NULL, 3, 1, 5, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, NULL, '2023-12-02 13:40:52', NULL);
INSERT INTO `sys_menu` VALUES (1730866270862831618, 'APP公告管理', 1730800447573925890, 'app-notice', 'ele-bell', 1, 1, 1, '/app-notice', 'AppNotice', NULL, 'operation/app-notice/index', 1, 0, 0, 0, NULL, '2023-12-02 16:27:31', '2023-12-02 16:30:24');
INSERT INTO `sys_menu` VALUES (1730866704637751298, 'APP版本管理', 1730800447573925890, 'app-version', 'ele-collection-tag', 1, 1, 2, '/app-version', 'AppVersion', NULL, 'operation/app-version/index', 1, 0, 0, 0, NULL, '2023-12-02 16:29:14', '2023-12-02 16:30:48');
INSERT INTO `sys_menu` VALUES (1730868159864107009, '会员管理', 1730800861144883201, 'member', 'ele-user', 1, 1, 1, '/member', 'Member', NULL, 'member/member/index', 1, 0, 0, 0, NULL, '2023-12-02 16:35:01', '2023-12-02 16:35:36');
INSERT INTO `sys_menu` VALUES (1730869463311183874, '常用语标签', 1730800861144883201, 'phrase-label', 'ele-flag', 1, 1, 2, '/phrase-label', 'PhraseLabel', NULL, 'member/phrase-label/index', 1, 0, 0, 0, NULL, '2023-12-02 16:40:12', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` bigint NOT NULL COMMENT '主键',
  `name` varchar(32) NOT NULL COMMENT '角色名称',
  `code` varchar(100) DEFAULT NULL COMMENT '角色唯一编码',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '角色状态，0：禁用，1：启用',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `sys_role_name_uindex` (`name`),
  UNIQUE KEY `sys_role_code_uindex` (`code`),
  KEY `sys_role_status_index` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统角色';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (1, '管理员', 'admin', 1, NULL, '2023-02-15 13:22:21', NULL);
INSERT INTO `sys_role` VALUES (2, '测试', 'test', 1, NULL, '2023-02-15 13:22:29', NULL);
INSERT INTO `sys_role` VALUES (3, '11', '22', 1, NULL, '2023-06-18 07:48:24', '2023-06-18 07:48:31');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` bigint NOT NULL COMMENT '主键',
  `role_id` bigint DEFAULT NULL COMMENT '角色id',
  `menu_id` bigint DEFAULT NULL COMMENT '菜单id',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `sys_role_menu_menu_id_index` (`menu_id`),
  KEY `sys_role_menu_role_id_index` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色菜单关系表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` VALUES (1, 2, 10, '2023-06-18 20:47:19', NULL);
INSERT INTO `sys_role_menu` VALUES (2, 2, 11, '2023-06-18 20:47:19', NULL);
INSERT INTO `sys_role_menu` VALUES (3, 2, 1101, '2023-06-18 20:47:19', NULL);
INSERT INTO `sys_role_menu` VALUES (4, 2, 1102, '2023-06-18 20:47:19', NULL);
INSERT INTO `sys_role_menu` VALUES (5, 2, 1103, '2023-06-18 20:47:19', NULL);
INSERT INTO `sys_role_menu` VALUES (6, 2, 1104, '2023-06-18 20:47:19', NULL);
INSERT INTO `sys_role_menu` VALUES (7, 2, 110101, '2023-06-18 20:47:20', NULL);
INSERT INTO `sys_role_menu` VALUES (8, 2, 110102, '2023-06-18 20:47:20', NULL);
INSERT INTO `sys_role_menu` VALUES (9, 2, 110103, '2023-06-18 20:47:20', NULL);
INSERT INTO `sys_role_menu` VALUES (10, 2, 110104, '2023-06-18 20:47:20', NULL);
INSERT INTO `sys_role_menu` VALUES (11, 2, 110105, '2023-06-18 20:47:20', NULL);
INSERT INTO `sys_role_menu` VALUES (12, 2, 110106, '2023-06-18 20:47:20', NULL);
INSERT INTO `sys_role_menu` VALUES (13, 2, 110201, '2023-06-18 20:47:20', NULL);
INSERT INTO `sys_role_menu` VALUES (14, 2, 110202, '2023-06-18 20:47:21', NULL);
INSERT INTO `sys_role_menu` VALUES (15, 2, 110203, '2023-06-18 20:47:21', NULL);
INSERT INTO `sys_role_menu` VALUES (16, 2, 110204, '2023-06-18 20:47:21', NULL);
INSERT INTO `sys_role_menu` VALUES (17, 2, 110205, '2023-06-18 20:47:21', NULL);
INSERT INTO `sys_role_menu` VALUES (18, 2, 110206, '2023-06-18 20:47:21', NULL);
INSERT INTO `sys_role_menu` VALUES (1671311250660831233, 1671308003090935810, 1101, '2023-06-21 08:17:08', NULL);
INSERT INTO `sys_role_menu` VALUES (1671311250660831234, 1671308003090935810, 110101, '2023-06-21 08:17:08', NULL);
INSERT INTO `sys_role_menu` VALUES (1671311250660831235, 1671308003090935810, 110102, '2023-06-21 08:17:08', NULL);
INSERT INTO `sys_role_menu` VALUES (1671311250665025537, 1671308003090935810, 110103, '2023-06-21 08:17:08', NULL);
INSERT INTO `sys_role_menu` VALUES (1671311250665025538, 1671308003090935810, 110104, '2023-06-21 08:17:08', NULL);
INSERT INTO `sys_role_menu` VALUES (1671311250665025539, 1671308003090935810, 110105, '2023-06-21 08:17:08', NULL);
INSERT INTO `sys_role_menu` VALUES (1671311250665025540, 1671308003090935810, 110106, '2023-06-21 08:17:08', NULL);
INSERT INTO `sys_role_menu` VALUES (1671596865650552833, 3, 1101, '2023-06-22 03:12:04', NULL);
INSERT INTO `sys_role_menu` VALUES (1671596865658941442, 3, 110101, '2023-06-22 03:12:04', NULL);
INSERT INTO `sys_role_menu` VALUES (1671596865658941443, 3, 110102, '2023-06-22 03:12:04', NULL);
INSERT INTO `sys_role_menu` VALUES (1671596865658941444, 3, 110103, '2023-06-22 03:12:04', NULL);
INSERT INTO `sys_role_menu` VALUES (1671596865663135745, 3, 110104, '2023-06-22 03:12:04', NULL);
INSERT INTO `sys_role_menu` VALUES (1671596865663135746, 3, 110105, '2023-06-22 03:12:04', NULL);
INSERT INTO `sys_role_menu` VALUES (1671596865663135747, 3, 110106, '2023-06-22 03:12:04', NULL);
INSERT INTO `sys_role_menu` VALUES (1672234918605877250, 1672234730873024514, 10, '2023-06-23 21:27:32', NULL);
INSERT INTO `sys_role_menu` VALUES (1672234918605877251, 1672234730873024514, 1101, '2023-06-23 21:27:32', NULL);
INSERT INTO `sys_role_menu` VALUES (1672234918610071554, 1672234730873024514, 110101, '2023-06-23 21:27:32', NULL);
INSERT INTO `sys_role_menu` VALUES (1672234918610071555, 1672234730873024514, 110102, '2023-06-23 21:27:32', NULL);
INSERT INTO `sys_role_menu` VALUES (1672234918610071556, 1672234730873024514, 110103, '2023-06-23 21:27:32', NULL);
INSERT INTO `sys_role_menu` VALUES (1672234918610071557, 1672234730873024514, 110104, '2023-06-23 21:27:32', NULL);
INSERT INTO `sys_role_menu` VALUES (1672234918610071558, 1672234730873024514, 110105, '2023-06-23 21:27:32', NULL);
INSERT INTO `sys_role_menu` VALUES (1672234918610071559, 1672234730873024514, 110106, '2023-06-23 21:27:32', NULL);
INSERT INTO `sys_role_menu` VALUES (1672234918610071560, 1672234730873024514, 110201, '2023-06-23 21:27:32', NULL);
INSERT INTO `sys_role_menu` VALUES (1672234918610071561, 1672234730873024514, 110202, '2023-06-23 21:27:32', NULL);
INSERT INTO `sys_role_menu` VALUES (1672234918618460161, 1672234730873024514, 110203, '2023-06-23 21:27:32', NULL);
INSERT INTO `sys_role_menu` VALUES (1672234918618460162, 1672234730873024514, 110204, '2023-06-23 21:27:33', NULL);
INSERT INTO `sys_role_menu` VALUES (1672234918618460163, 1672234730873024514, 110302, '2023-06-23 21:27:33', NULL);
INSERT INTO `sys_role_menu` VALUES (1672234918618460164, 1672234730873024514, 110303, '2023-06-23 21:27:33', NULL);
INSERT INTO `sys_role_menu` VALUES (1672234918618460165, 1672234730873024514, 110304, '2023-06-23 21:27:33', NULL);
INSERT INTO `sys_role_menu` VALUES (1672234918618460166, 1672234730873024514, 110305, '2023-06-23 21:27:33', NULL);
INSERT INTO `sys_role_menu` VALUES (1672234918618460167, 1672234730873024514, 110306, '2023-06-23 21:27:33', NULL);
INSERT INTO `sys_role_menu` VALUES (1672234918618460168, 1672234730873024514, 1104, '2023-06-23 21:27:33', NULL);
INSERT INTO `sys_role_menu` VALUES (1672234918618460169, 1672234730873024514, 110401, '2023-06-23 21:27:33', NULL);
INSERT INTO `sys_role_menu` VALUES (1672234918618460170, 1672234730873024514, 110402, '2023-06-23 21:27:33', NULL);
INSERT INTO `sys_role_menu` VALUES (1672234918618460171, 1672234730873024514, 110403, '2023-06-23 21:27:33', NULL);
INSERT INTO `sys_role_menu` VALUES (1672234918618460172, 1672234730873024514, 110404, '2023-06-23 21:27:33', NULL);
INSERT INTO `sys_role_menu` VALUES (1672234918622654465, 1672234730873024514, 110405, '2023-06-23 21:27:33', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` bigint NOT NULL COMMENT '主键',
  `username` varchar(20) NOT NULL COMMENT '用户名',
  `nickname` varchar(20) NOT NULL COMMENT '昵称',
  `password` varchar(64) NOT NULL COMMENT '密码',
  `salt` varchar(32) NOT NULL COMMENT '盐值',
  `phone` varchar(20) DEFAULT NULL COMMENT '手机号码',
  `email` varchar(255) DEFAULT NULL COMMENT '电子邮件',
  `gender` tinyint NOT NULL DEFAULT '0' COMMENT '性别，0：未知，1：男，2：女，默认0',
  `head` varchar(100) DEFAULT NULL COMMENT '头像',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态，0：禁用，1：启用',
  `dept_id` bigint DEFAULT NULL COMMENT '部门id',
  `is_admin` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否是超管 0：否，1：是',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `sys_us` (`username`),
  KEY `sys_user_dept_id_index` (`dept_id`),
  KEY `sys_user_status_index` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统用户';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1, 'admin', '管理员', '35d9d2ad09f0a7b0c2b3143bd60affb719766972aa720827c97240ea04d0f304', '94132dcd55eb478bb63170a2fa510ea1', '15812345678', 'aaron.wang@qq.com', 1, 'http://127.0.0.1:8888/file/20231129222255660517059.jpeg', 1, 1669290098346250241, 1, '2023-02-15 13:21:02', '2023-06-25 16:55:18');
INSERT INTO `sys_user` VALUES (2, 'test', '测试', 'aa588acb55ee7ec0d7f2107a40bb47cfac8b73cf7cb1217a6930aecb3bf178ee', '666', '13577777777', 'asadasfasf', 0, NULL, 1, 1669290098346250241, 0, '2023-05-08 21:38:33', '2023-06-21 07:33:23');
INSERT INTO `sys_user` VALUES (3, 'cs', 'cs', 'aa588acb55ee7ec0d7f2107a40bb47cfac8b73cf7cb1217a6930aecb3bf178ee', '666', '13577777777', '121321@qq.com', 0, NULL, 0, 2, 0, '2023-06-16 04:00:45', '2023-06-22 03:01:20');
INSERT INTO `sys_user` VALUES (1672233328339709953, 'hello', 'xxx', '4bce435e22d61fc3e538964fe70ad920a071db6b8151c3e92f6203b20e5e447b', '2aa67c95f2214c52bb57072fa3b909ac', '18889898989', '2929@qa.com', 1, NULL, 1, 1, 0, '2023-06-23 21:21:13', '2023-06-25 20:50:46');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` bigint NOT NULL COMMENT '主键',
  `user_id` bigint DEFAULT NULL COMMENT '用户id',
  `role_id` bigint DEFAULT NULL COMMENT '角色id',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `sys_user_role_role_id_index` (`role_id`),
  KEY `sys_user_role_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户角色关系表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES (1671300240755437570, 2, 2, '2023-06-21 07:33:23', NULL);
INSERT INTO `sys_user_role` VALUES (1671550509347106817, 1, 1, '2023-06-22 00:07:51', NULL);
INSERT INTO `sys_user_role` VALUES (1671550509359689729, 1, 2, '2023-06-22 00:07:51', NULL);
INSERT INTO `sys_user_role` VALUES (1671594161742147585, 3, 1, '2023-06-22 03:01:19', NULL);
INSERT INTO `sys_user_role` VALUES (1672950457731936258, 1672233328339709953, 2, '2023-06-25 20:50:45', NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
